package cn.stylefeng.guns.sys.modular.dbServicelist.entity;

import com.baomidou.mybatisplus.annotation.TableName;
import com.baomidou.mybatisplus.annotation.IdType;

import java.util.Date;

import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableField;
import io.swagger.models.auth.In;

import java.io.Serializable;

/**
 * <p>
 * 目录服务
 * </p>
 *
 * @author zhaoyiheng
 * @since 2020-08-19
 */
@TableName("db_servicelist")
public class DbServicelist implements Serializable {

    private static final long serialVersionUID = 1L;

    /**
     * id
     */
    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    /**
     * 部门 部门
     */
    @TableField("department")
    private String department;

    /**
     * 数据库 数据库
     */
    @TableField("dbName")
    private String dbName;

    /**
     * 用户id
     */
    @TableField("userId")
    private Long userId;

    /**
     * 账号
     */
    @TableField("username")
    private String username;

    /**
     * 密码
     */
    @TableField("password")
    private String password;

    /**
     * 服务类型
     */
    @TableField("servicetype")
    private String servicetype;


    /**
     * 服务类型
     */
    @TableField("jdbc_url")
    private String jdbcUrl;

    /**
     * 服务类型
     */
    @TableField("db_url")
    private String dbUrl;

    /**
     * 服务类型
     */
    @TableField("db_number")
    private String dbNumber;

    /**
     * 应用系统
     */
    @TableField("system")
    private String system;

    /**
     * 说明
     */
    @TableField("details")
    private String details;

    /**
     * 使用规范
     */
    @TableField("standard")
    private String standard;

    /**
     * 状态
     */
    @TableField("state")
    private String state;

    /**
     * 审批状态
     */
    @TableField("spState")
    private String spState;
    /**
     * 数据库内存
     */
    @TableField("db_memory")
    private String dbMemory;

    /**
     * 交换机id
     */
    @TableField("exchange_id")
    private String exchangeId;

    /**
     * 交换频率
     */
    @TableField("exchange_date")
    private String exchangeDate;

    /**
     * 交换机id
     */
    @TableField("db_type")
    private String dbType;

    /**
     * 是否公开
     */
    @TableField("open")
    private String open;

    /**
     * 到期时间
     */
    @TableField("effectiveTime")
    private String effectiveTime;

    /**
     * 备注
     */
    @TableField("remarks")
    private String remarks;

    /**
     * 乐观锁
     */
    @TableField("REVISION")
    private Integer revision;

    /**
     * 创建人
     */
    @TableField("CREATED_BY")
    private String createdBy;

    /**
     * 创建时间
     */
    @TableField("CREATED_TIME")
    private Date createdTime;

    /**
     * 更新人
     */
    @TableField("UPDATED_BY")
    private String updatedBy;

    /**
     * 更新时间
     */
    @TableField("UPDATED_TIME")
    private Date updatedTime;


    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getDepartment() {
        return department;
    }

    public void setDepartment(String department) {
        this.department = department;
    }

    public String getDbName() {
        return dbName;
    }

    public void setDbName(String dbName) {
        this.dbName = dbName;
    }

    public Long getUserId() {
        return userId;
    }

    public void setUserId(Long userId) {
        this.userId = userId;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getServicetype() {
        return servicetype;
    }

    public void setServicetype(String servicetype) {
        this.servicetype = servicetype;
    }

    public String getSystem() {
        return system;
    }

    public void setSystem(String system) {
        this.system = system;
    }

    public String getDetails() {
        return details;
    }

    public void setDetails(String details) {
        this.details = details;
    }

    public String getStandard() {
        return standard;
    }

    public void setStandard(String standard) {
        this.standard = standard;
    }

    public String getState() {
        return state;
    }

    public void setState(String state) {
        this.state = state;
    }

    public String getSpState() {
        return spState;
    }

    public void setSpState(String spState) {
        this.spState = spState;
    }

    public String getOpen() {
        return open;
    }

    public void setOpen(String open) {
        this.open = open;
    }

    public String getEffectiveTime() {
        return effectiveTime;
    }

    public void setEffectiveTime(String effectiveTime) {
        this.effectiveTime = effectiveTime;
    }

    public String getRemarks() {
        return remarks;
    }

    public void setRemarks(String remarks) {
        this.remarks = remarks;
    }

    public Integer getRevision() {
        return revision;
    }

    public void setRevision(Integer revision) {
        this.revision = revision;
    }

    public String getCreatedBy() {
        return createdBy;
    }

    public void setCreatedBy(String createdBy) {
        this.createdBy = createdBy;
    }

    public Date getCreatedTime() {
        return createdTime;
    }

    public void setCreatedTime(Date createdTime) {
        this.createdTime = createdTime;
    }

    public String getUpdatedBy() {
        return updatedBy;
    }

    public void setUpdatedBy(String updatedBy) {
        this.updatedBy = updatedBy;
    }

    public Date getUpdatedTime() {
        return updatedTime;
    }

    public void setUpdatedTime(Date updatedTime) {
        this.updatedTime = updatedTime;
    }

    public String getDbUrl() {
        return dbUrl;
    }

    public void setDbUrl(String dbUrl) {
        this.dbUrl = dbUrl;
    }

    public String getDbNumber() {
        return dbNumber;
    }

    public void setDbNumber(String dbNumber) {
        this.dbNumber = dbNumber;
    }

    public String getDbMemory() {
        return dbMemory;
    }

    public void setDbMemory(String dbMemory) {
        this.dbMemory = dbMemory;
    }

    public String getExchangeDate() {
        return exchangeDate;
    }

    public void setExchangeDate(String exchangeDate) {
        this.exchangeDate = exchangeDate;
    }

    public String getExchangeId() {
        return exchangeId;
    }

    public void setExchangeId(String exchangeId) {
        this.exchangeId = exchangeId;
    }

    public String getDbType() {
        return dbType;
    }

    public void setDbType(String dbType) {
        this.dbType = dbType;
    }

    public String getJdbcUrl() {
        return jdbcUrl;
    }

    public void setJdbcUrl(String jdbcUrl) {
        this.jdbcUrl = jdbcUrl;
    }

    @Override
    public String toString() {
        return "DbServicelist{" +
                "id=" + id +
                ", department=" + department +
                ", dbName=" + dbName +
                ", userId=" + userId +
                ", username=" + username +
                ", password=" + password +
                ", dbMemory=" + dbMemory +
                ", servicetype=" + servicetype +
                ", dbUrl=" + dbUrl +
                ", dbNumber=" + dbNumber +
                ", system=" + system +
                ", details=" + details +
                ", standard=" + standard +
                ", state=" + state +
                ", spState=" + spState +
                ", exchangeDate=" + exchangeDate +
                ", exchangeId=" + exchangeId +
                ", dbType=" + dbType +
                ", open=" + open +
                ", effectiveTime=" + effectiveTime +
                ", remarks=" + remarks +
                ", revision=" + revision +
                ", createdBy=" + createdBy +
                ", createdTime=" + createdTime +
                ", updatedBy=" + updatedBy +
                ", updatedTime=" + updatedTime +
                ", jdbcUrl=" + jdbcUrl +
                "}";
    }
}
